Tabela PhPackHist

Definicja tabeli PhPackHist

Name

PhPackHist

Code

PhPackHist

Comment

Opakowanie leku


Lista kolumn tabeli PhPackHist

Name

Code

PackID

PackID

ResourceID

ResourceID

Active

Active

Quantity

Quantity

MeasureUnitID

MeasureUnitID

PackUnitID

PackUnitID

EanCode

EanCode

Bazyl

Bazyl

Bloz

Bloz

EuRegistryNo

EuRegistryNo

PackStatus

PackStatus

Deleted

Deleted

PortionDef

PortionDef

PortionUnitID

PortionUnitID

ActiveIngrInPortion

ActiveIngrInPortion

ActiveIngrUnitID

ActiveIngrUnitID

PriceType

PriceType

PriceDT

PriceDT

PackRefunded

PackRefunded

PortionLimit

PortionLimit

PackLimit

PackLimit

VatRateID

VatRateID

JwcID

JwcID

BazylID

BazylID

Description

Description

RegisterDate

RegisterDate

Register

Register

RegistryNumber

RegistryNumber

Authorized

Authorized

HospitalPack

HospitalPack

OffPrizeSell

OffPrizeSell

OffPrizeWhole

OffPrizeWhole

OffPrizeDet

OffPrizeDet

OffPriceLimit

OffPriceLimit

OffPriceMax

OffPriceMax

HashCode

HashCode

ExternalID

ExternalID

rev

rev

RevTypeId

RevTypeId


Kolumna PackID tabeli PhPackHist

Definicja kolumny PackID tabeli PhPackHist

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli PhPackHist

Definicja kolumny ResourceID tabeli PhPackHist

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli PhPackHist

Definicja kolumny Active tabeli PhPackHist

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w systemie


Kolumna Quantity tabeli PhPackHist

Definicja kolumny Quantity tabeli PhPackHist

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

Ilosc


Kolumna MeasureUnitID tabeli PhPackHist

Definicja kolumny MeasureUnitID tabeli PhPackHist

Name

MeasureUnitID

Code

MeasureUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID jednostki miary


Kolumna PackUnitID tabeli PhPackHist

Definicja kolumny PackUnitID tabeli PhPackHist

Name

PackUnitID

Code

PackUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID jednostki opakowania


Kolumna EanCode tabeli PhPackHist

Definicja kolumny EanCode tabeli PhPackHist

Name

EanCode

Code

EanCode

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod EAN (kod kreskowy)


Kolumna Bazyl tabeli PhPackHist

Definicja kolumny Bazyl tabeli PhPackHist

Name

Bazyl

Code

Bazyl

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer BAZYL


Kolumna Bloz tabeli PhPackHist

Definicja kolumny Bloz tabeli PhPackHist

Name

Bloz

Code

Bloz

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer BLOZ


Kolumna EuRegistryNo tabeli PhPackHist

Definicja kolumny EuRegistryNo tabeli PhPackHist

Name

EuRegistryNo

Code

EuRegistryNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer rejestru Unii Europejskiej


Kolumna PackStatus tabeli PhPackHist

Definicja kolumny PackStatus tabeli PhPackHist

Name

PackStatus

Code

PackStatus

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Status opakowania


Kolumna Deleted tabeli PhPackHist

Definicja kolumny Deleted tabeli PhPackHist

Name

Deleted

Code

Deleted

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga usuniecia


Kolumna PortionDef tabeli PhPackHist

Definicja kolumny PortionDef tabeli PhPackHist

Name

PortionDef

Code

PortionDef

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Definicja porcji


Kolumna PortionUnitID tabeli PhPackHist

Definicja kolumny PortionUnitID tabeli PhPackHist

Name

PortionUnitID

Code

PortionUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki definicji porcji


Kolumna ActiveIngrInPortion tabeli PhPackHist

Definicja kolumny ActiveIngrInPortion tabeli PhPackHist

Name

ActiveIngrInPortion

Code

ActiveIngrInPortion

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc skladnika aktywnego w porcji


Kolumna ActiveIngrUnitID tabeli PhPackHist

Definicja kolumny ActiveIngrUnitID tabeli PhPackHist

Name

ActiveIngrUnitID

Code

ActiveIngrUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki ilosci skladnika aktywnego w porcji


Kolumna PriceType tabeli PhPackHist

Definicja kolumny PriceType tabeli PhPackHist

Name

PriceType

Code

PriceType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Typ ceny


Kolumna PriceDT tabeli PhPackHist

Definicja kolumny PriceDT tabeli PhPackHist

Name

PriceDT

Code

PriceDT

Data Type

DATE

Mandatory

No

Comment

Data ustalenia ceny


Kolumna PackRefunded tabeli PhPackHist

Definicja kolumny PackRefunded tabeli PhPackHist

Name

PackRefunded

Code

PackRefunded

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga refundacji leku


Kolumna PortionLimit tabeli PhPackHist

Definicja kolumny PortionLimit tabeli PhPackHist

Name

PortionLimit

Code

PortionLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Limit porcji


Kolumna PackLimit tabeli PhPackHist

Definicja kolumny PackLimit tabeli PhPackHist

Name

PackLimit

Code

PackLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Limit opakowania


Kolumna VatRateID tabeli PhPackHist

Definicja kolumny VatRateID tabeli PhPackHist

Name

VatRateID

Code

VatRateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID stawki VAT


Kolumna JwcID tabeli PhPackHist

Definicja kolumny JwcID tabeli PhPackHist

Name

JwcID

Code

JwcID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID ze slownika JWC


Kolumna BazylID tabeli PhPackHist

Definicja kolumny BazylID tabeli PhPackHist

Name

BazylID

Code

BazylID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

ID ze slownika BAZYL


Kolumna Description tabeli PhPackHist

Definicja kolumny Description tabeli PhPackHist

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna RegisterDate tabeli PhPackHist

Definicja kolumny RegisterDate tabeli PhPackHist

Name

RegisterDate

Code

RegisterDate

Data Type

DATE

Mandatory

No

Comment

Data wpisania leku do rejestru


Kolumna Register tabeli PhPackHist

Definicja kolumny Register tabeli PhPackHist

Name

Register

Code

Register

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa rejestru


Kolumna RegistryNumber tabeli PhPackHist

Definicja kolumny RegistryNumber tabeli PhPackHist

Name

RegistryNumber

Code

RegistryNumber

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer rejestru


Kolumna Authorized tabeli PhPackHist

Definicja kolumny Authorized tabeli PhPackHist

Name

Authorized

Code

Authorized

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Produkt dopuszczony do obrotu


Kolumna HospitalPack tabeli PhPackHist

Definicja kolumny HospitalPack tabeli PhPackHist

Name

HospitalPack

Code

HospitalPack

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Opakowanie szpitalne


Kolumna OffPrizeSell tabeli PhPackHist

Definicja kolumny OffPrizeSell tabeli PhPackHist

Name

OffPrizeSell

Code

OffPrizeSell

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa zbytu


Kolumna OffPrizeWhole tabeli PhPackHist

Definicja kolumny OffPrizeWhole tabeli PhPackHist

Name

OffPrizeWhole

Code

OffPrizeWhole

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa hurt


Kolumna OffPrizeDet tabeli PhPackHist

Definicja kolumny OffPrizeDet tabeli PhPackHist

Name

OffPrizeDet

Code

OffPrizeDet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena urzedowa detal


Kolumna OffPriceLimit tabeli PhPackHist

Definicja kolumny OffPriceLimit tabeli PhPackHist

Name

OffPriceLimit

Code

OffPriceLimit

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena limitu


Kolumna OffPriceMax tabeli PhPackHist

Definicja kolumny OffPriceMax tabeli PhPackHist

Name

OffPriceMax

Code

OffPriceMax

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena maksymalna


Kolumna HashCode tabeli PhPackHist

Definicja kolumny HashCode tabeli PhPackHist

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Skrót z pól rekordu


Kolumna ExternalID tabeli PhPackHist

Definicja kolumny ExternalID tabeli PhPackHist

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

Zewnetrzny identyfikator


Kolumna rev tabeli PhPackHist

Definicja kolumny rev tabeli PhPackHist

Name

rev

Code

rev

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RevTypeId tabeli PhPackHist

Definicja kolumny RevTypeId tabeli PhPackHist

Name

RevTypeId

Code

RevTypeId

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Lista kluczy tabeli PhPackHist

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhPackHist

Definicja klucza Key_1 tabeli PhPackHist

Name

Key_1

Code

Key_1

Primary

Yes

Comment